UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'mVn5FwEjpyQOXyOL0xdimKfv93VdpgViNBiAV/opvOE=' 
WHERE 
  key_id = 'ebdfc4e3927b32461e08699658df97022fb9e6d3de7f9d025e7613aadfd78658' 
  AND (
    token = 'mVn5FwEjpyQOXyOL0xdimKfv93VdpgViNBiAV/opvOE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00024