UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TZuIw7TJe0UGzZKsOTgRQBj2hsnRNcoAnX6J7a4t6sA='
WHERE
key_id = '03fffe510808766c4ba3bc3139e969b1d8428d6f5c3aeb536ec1bc12198d4b51'
AND (
token = 'TZuIw7TJe0UGzZKsOTgRQBj2hsnRNcoAnX6J7a4t6sA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)