UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'zzpF8i4G0YpQh3ojqe63UbgMpFEuuYj+t2kGSqXoqQI=' 
WHERE 
  key_id = 'ea3b4fde7b20f170a16d7c744fcc30469160b8d5639ce56d99808848e821b88b' 
  AND (
    token = 'zzpF8i4G0YpQh3ojqe63UbgMpFEuuYj+t2kGSqXoqQI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027