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