UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1e+nb26jOQ1zRSA3FVpnyx9mFM8mwmpu8x6DUF46c30='
WHERE
key_id = 'a23e37ae860ae9d6af7374c4f4c94ce9219961f31ccaaafa8b4399fc45aa0767'
AND (
token = '1e+nb26jOQ1zRSA3FVpnyx9mFM8mwmpu8x6DUF46c30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)