UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'lBpJS1V7H/rOGjRsUetQQOY5NTXHdmvLecDWist4zSY=' 
WHERE 
  key_id = '49b81cf6ef2f91d0f52858a6aa14fd44cf4b9b3387ef9d28253b04d067b3d32f' 
  AND (
    token = 'lBpJS1V7H/rOGjRsUetQQOY5NTXHdmvLecDWist4zSY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022