UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'at8ZAy9ybOXGbA+VMWEcFWSjZXQ4VQvwqiDUFkFriUA='
WHERE
key_id = '04db16dc036b55cf5329d8096ba80ae7b7fd443c0c49e1a1c09c292374df6f80'
AND (
token = 'at8ZAy9ybOXGbA+VMWEcFWSjZXQ4VQvwqiDUFkFriUA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)