UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DiNBW/4y7G8pmyGcJ8QQyT0NHoG7TEiy/+Vs+HAJiYY=' 
WHERE 
  key_id = 'd3544429eb670effa47578ad9359aa12fd270bb7de652aeb5aa09324ff07b4a3' 
  AND (
    token = 'DiNBW/4y7G8pmyGcJ8QQyT0NHoG7TEiy/+Vs+HAJiYY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027