UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tww6IJMmwURNj9wI37M9VZpzeZ5Xlkrth2gQ0djRv2w='
WHERE
key_id = '6185073969d15bea1a8b489a136ef1a89577638a457d5c7613bb6a023d411366'
AND (
token = 'tww6IJMmwURNj9wI37M9VZpzeZ5Xlkrth2gQ0djRv2w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)