UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '8nAwmvEu52Mz919YBFXjJ7bKIOFSi4mF2KtMrOMIQlA=' 
WHERE 
  key_id = 'b6c5e8d78ef9bfeadbae770a4ae30454636fb6139fce402595f153a33d2ca4dc' 
  AND (
    token = '8nAwmvEu52Mz919YBFXjJ7bKIOFSi4mF2KtMrOMIQlA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036