UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hC8sVESd3HCd/6HpIlsp9JwioIwMTVM5/D2KwS1hqWg='
WHERE
key_id = '59a3562245339683655d2c328cc008cee79c63458a633abd04086d1914f29be5'
AND (
token = 'hC8sVESd3HCd/6HpIlsp9JwioIwMTVM5/D2KwS1hqWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)