UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzOh1zu+dxutn0K2qu19AM0cK1c7GrDdWOYBk1L5Qj8='
WHERE
key_id = 'c81a89fb967d319ebad59947ebb29abf1a7bf42e9f0d40fc9dd4ece32619bddd'
AND (
token = 'HzOh1zu+dxutn0K2qu19AM0cK1c7GrDdWOYBk1L5Qj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)