UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ri2cAYvstSrD181z1Hv/DeXoUbLP4aRzqrKpqLto8LU='
WHERE
key_id = 'bc942979e7e10b8b54f681d91e94d774a3a097b884adc8a3f04fb3cc202b0012'
AND (
token = 'ri2cAYvstSrD181z1Hv/DeXoUbLP4aRzqrKpqLto8LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)