UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PQgVkceRxJAiAKPR50P4lb4VazrsOKOOYTfUTnxyFy8='
WHERE
key_id = 'c06db2d9555dcb49524146b4cf9e3e528d175f65b8223305f96ce53f55666bce'
AND (
token = 'PQgVkceRxJAiAKPR50P4lb4VazrsOKOOYTfUTnxyFy8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)