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