UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p+LPyR9KUU86HjOTmISwbIguh/GNj/lK6p/P1VAHqY8='
WHERE
key_id = '127e4cde2e5faae5f5e5dae2bd783d1a1d546680993b23c17333d2541600346e'
AND (
token = 'p+LPyR9KUU86HjOTmISwbIguh/GNj/lK6p/P1VAHqY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)