UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sqdpbhE0zQEX16X1mN0jz4ykm31Iu3qQm6aUZGDZGSE='
WHERE
key_id = '9f817f095dcd6504e0a7074bdcc9deb3081664ce348dbbe80af1e576e2d9b9de'
AND (
token = 'sqdpbhE0zQEX16X1mN0jz4ykm31Iu3qQm6aUZGDZGSE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)