UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xd0cUDD/D6xu7C/oI0En7G37/doqq+RR7uynosHF1Rk='
WHERE
key_id = '8bc41c340d6a126e6876daea645dda072f4ad734da5250c5db7f277c341a5c82'
AND (
token = 'Xd0cUDD/D6xu7C/oI0En7G37/doqq+RR7uynosHF1Rk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)