UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpJARiQHziiH8hY68knf5IjPzJ4JnkdrY4WbIpLkjXo='
WHERE
key_id = 'c3b93a6a61a1931dd1007a584a08d6896a4a31fec7b7d8a823465d6eba122e7b'
AND (
token = 'ZpJARiQHziiH8hY68knf5IjPzJ4JnkdrY4WbIpLkjXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)