UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gAJlWe85q9i7dHmkZFdLvRH3eMcmbqum5Vul/M5Ss+k='
WHERE
key_id = '78de5e3da70fa88a5d98b0e1231e3070885b2da72607e37197085979f0ed5c57'
AND (
token = 'gAJlWe85q9i7dHmkZFdLvRH3eMcmbqum5Vul/M5Ss+k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)