UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '78W+VJx+wEihMECIN3xwymvCrXMqut0eF23f00Y+bFw='
WHERE
key_id = 'a06036349e2d9a40aa624bf54458d2ff278786062b27d9f4c5013fc50200bfa8'
AND (
token = '78W+VJx+wEihMECIN3xwymvCrXMqut0eF23f00Y+bFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)