UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XR/My6uIf/xAWu5Sv7OpkLQ4TvbkCWaPBzaw7/GDAYU='
WHERE
key_id = 'a15a6498487eee1f44711e51a23b6b4554e229fadf2089e1025ffce7f20668c5'
AND (
token = 'XR/My6uIf/xAWu5Sv7OpkLQ4TvbkCWaPBzaw7/GDAYU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)