UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gozWKiaQ9+MHAhORwPy28b1wXpgRf73ll/I/Iy5KTcc='
WHERE
key_id = '6b502852f45d4009a0a84ae17657fbbe4f8f64aa536665772e4dbc193639de09'
AND (
token = 'gozWKiaQ9+MHAhORwPy28b1wXpgRf73ll/I/Iy5KTcc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)