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