UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/AQ1gX3SXcuVr3YH4rxagFuwRa2wV+03CiUVLGDgc1w=' 
WHERE 
  key_id = '39caf36011141c01556411fa3cc104c3d678309572455acac95f317cd2880581' 
  AND (
    token = '/AQ1gX3SXcuVr3YH4rxagFuwRa2wV+03CiUVLGDgc1w=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00029