UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yptkTkl2Jt8VlDGfXnfxXD7j04QdI7DOB5qZnwiffu0='
WHERE
key_id = '8e8492be99fe17d843405ccd5165e7e5877bf370c0bee2f9cdd4d59af725b0ae'
AND (
token = 'yptkTkl2Jt8VlDGfXnfxXD7j04QdI7DOB5qZnwiffu0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)