UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IojMVI/8xvzGDauW8dfurHqMd4DuIllz1kJIqgxL+IA='
WHERE
key_id = 'f38d1f82af63a25a71b68dc6858d22f6700ac3a7ebfa0771bbd292d7171f3dbe'
AND (
token = 'IojMVI/8xvzGDauW8dfurHqMd4DuIllz1kJIqgxL+IA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)