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