UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Ql6Rlb4y2s6HyEFbufw9958ib1Z4XlAr2VaEGyOvLG4='
WHERE
key_id = '9c37da9fd24304cde3a29489984854f7a789d2004d1228aebdba84d56384783a'
AND (
token = 'Ql6Rlb4y2s6HyEFbufw9958ib1Z4XlAr2VaEGyOvLG4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)