UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7rEHOr1y5pZ3yh7g5juuQ4ilwVtXe0HmyOS5K1ykOpU='
WHERE
key_id = 'b85aef109246ea215ce3099439edc80f5437b731c9883c251a6903ee148aa5f7'
AND (
token = '7rEHOr1y5pZ3yh7g5juuQ4ilwVtXe0HmyOS5K1ykOpU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)