UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E/3vLbqHg1oNpRCeye00gkn4/IZMulbIS8tThi0ROKE='
WHERE
key_id = '9e565bc344e31bf58561701b80d134345b6baebe0d1a9e1c99f8d9c399c8af94'
AND (
token = 'E/3vLbqHg1oNpRCeye00gkn4/IZMulbIS8tThi0ROKE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)